How to: Add comma to numbers.
Solution:
Select the cell or range, select 'Cells...' from the 'Format' menu, and select 'Use 1000 Separator (,)' in the 'Number' properties sheet.
To insert commas in numbers:
1) Select the cell or range with the numbers to format.
2) Select the 'Format' menu and select 'Cells...'. (The Format Cells dialog box appears.)
3) Click the 'Number' tab.
4) Select 'Number' from the 'Category' list box.
5) Select the 'Use 1000 Separator (,)' check box.
6) (Optional) Adjust the decimal places for the numbers in the 'Decimal Places' box.
7) (Optional) Select the format for negative numbers in the 'Negative Numbers' list box.
8) Click 'OK'.
